package com.commerceerp.system.mapper;

import com.commerceerp.system.entity.PorderInfo;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

public interface PorderMapper {

    List<Map> getAllPlanPurchase(@Param("porderStorehouseId")String porderStorehouseId,@Param("goodSystemSku")String goodSystemSku,
                                 @Param("goodSystemChname")String goodSystemChname,@Param("porderStatus")String porderStatus,@Param("porderId")String porderId);

    Integer updPorderInfoById(PorderInfo porderInfo);

    Integer delPorderInfoById(String porderId);

    Integer saveNewPorderInfo(PorderInfo porderInfo);

    Map<String,Object> getPorderInfoById(String porderId);

    Integer getAdvicePorderByGoodId(String porderGoodId);

    List<Map> getCountByPorderStatus();

    Integer getCountByDiffPorderStatus(@Param("porderStatus") String porderStatus,@Param("porderGoodId") String porderGoodId);

}
